# -*- coding: utf-8 -*-#
#-------------------------------------------------------------------------------
# 建立者:        潘炎珍  
# Name:         demo11
# Description:
# Author:       98745
# Date:         2019/4/2
#-------------------------------------------------------------------------------

from sqlalchemy import create_engine,MetaData,Table,Column,Integer,String,Float,exc,orm
# from sqlalchemy.ext.declarative import declarative_base

mysql='mysql+pymysql://root:1997@localhost:3306/python?charset=utf8'
engine=create_engine(mysql,encoding='utf-8')
engine.connect()

metadata=MetaData(engine)
weather=Table(
    'weather',metadata,
    Column('place',String(10)),
    Column('time',String(30)),
    Column('weather',String(30)),
    Column('temperature',String(30)),
    Column('wind',String(30))
)
metadata.create_all(engine)
